create external table jms_dm.dm_alarm_cainiao_actual_network_tn_dt (
   date_time date comment '查询日期',
   count_t1 int comment '当天时效数量',
   count_t2 int comment '前1天时效数量',
   up_diff_count int comment '差异1：前1天有后1天无',
   current_diff_count int comment '差异2：前1天没有后1天有',
   aging_diff_cnt int comment '差异3：时效不同',
   diff_count int comment '总差异量',
   diff_rt decimal(16,4) comment '差异占比'
) COMMENT '数据监控_七星潭线路达成率动态达成时效天计算匹配静态规则'
PARTITIONED BY (dt STRING COMMENT '日期分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_alarm_cainiao_actual_network_tn_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);